home *** CD-ROM | disk | FTP | other *** search
/ PC-SIG: Essential Home & Business / PC-SIG - Essential Home and Business Collection.iso / 22 / 7 / 9 / DATAFILE.DOC next >
Text File  |  1990-05-06  |  5KB  |  103 lines
  1. Database Structure and Indexes:  EASYMAIL System
  2.  
  3.  
  4.  
  5. Database:   EASYMAIL.DBF
  6. Index File: EASYMAIL.IDX  Key: INITIALS
  7.  
  8. Field Name  Type  Width  Dec  Description
  9. ----------  ----  -----  ---  --------------------------------------
  10. INITIALS    Char      3       Unique initials to identify user
  11. FULL_NAME   Char     35       Full & complete name of authorized user
  12. PASSWORD    Char     10       Secret password of the user
  13. ACCESS      Nume      1       Access level (1=supervisor, 2=general)
  14. LAST_LOGIN  Char     19       Last date & time of login (MM/DD/YY - 99:99:99)
  15. NEW_MAIL    Logi      1       Is there new mail since last login
  16. ACTIVE_USR  Logi      1       Is this an active system user
  17. PRT_SETUP   Char     40       User defined printer setup code
  18. TOP_MAR     Nume      3       Top margin for printing (in lines)
  19. BOT_MAR     Nume      3       Bottom margin of paper (in lines)
  20. LEFT_MAR    Nume      2       Indent from left (in columns)
  21. RIGHT_MAR   Nume      3       Right margin from 0 left (in columns)
  22. DEVICE      Char      4       Output printer port (LPT1, LPT2, LPT3, LPT4)
  23.  
  24.  
  25. Database:   MAIL_DOC.DBF
  26. Index File: MAIL_DOC.IDX  Key: SERIAL_NO
  27. Index File: MAIL_DO1.IDX  Key: INITIALS
  28. Memo file:  MAIL_DOC.DBT
  29.  
  30. Field Name  Type  Width  Dec  Description
  31. ----------  ----  -----  ---  --------------------------------------
  32. INITIALS    Char      3       Unique initials to identify creator
  33. ORIG_INIT   Char      3       When the file is ARC/DEL this is INITIALS
  34. FULL_NAME   Char     35       Full & complete name of authorized user
  35. TITLE       Char     36       User assigned descriptive document title
  36. SERIAL_NO   Char      7       Computer assigned unique key ('SMT   3')
  37. CREATED     Char     19       Text date & time created (MM/DD/YY - 99:99:99)
  38. EDITED      Char     19       Last date & time edited (MM/DD/YY - 99:99:99)
  39. SENT        Char     19       Date & time when sent (MM/DD/YY - 99:99:99)
  40. UNOPENED    Nume      3       Number of users who have not opened it yet
  41. TEXT        Memo     10       Complete text of the document
  42. PRIORITY    Nume      1       Document priority level (1-archive, 2-delete)
  43.  
  44.  
  45. Database:   MAIL_TO.DBF
  46. Index File: MAIL_TO1.IDX  Key: SERIAL_NO
  47. Index File: MAIL_TO2.IDX  Key: INITIALS
  48.  
  49. Field Name  Type  Width  Dec  Description
  50. ----------  ----  -----  ---  --------------------------------------
  51. INITIALS    Char      3       Unique initials to identify reader
  52. ORIG_INIT   Char      3       When the file is ARC/DEL this is INITIALS
  53. SERIAL_NO   Char      7       Computer assigned unique key ('SMT   3')
  54. RECEIVED    Char     19       Date & time when rec'd (MM/DD/YY - 99:99:99)
  55. OPENED      Char     19       Date & time when opened (MM/DD/YY - 99:99:99)
  56.  
  57. Database Structure and Indexes:  EASYMAIL System
  58.  
  59.  
  60.  
  61.  
  62. Database:   HELPFILE.DBF
  63. Memo file:  HLEPFILE.DBT
  64.  
  65. Field Name  Type  Width  Dec  Description
  66. ----------  ----  -----  ---  --------------------------------------
  67. HELPID      Char     20       Unique key to identify help for a window
  68. TOP         Nume      2       Top row for window border
  69. LEFT        Nume      2       Left column for window border
  70. BOTT        Nume      2       Bottom row for shadow border
  71. RIGHT       Nume      2       Right column for shadow border
  72. TEXT        Memo     10       Memo text of help window
  73.  
  74.  
  75.  
  76. System Structure (program profile):
  77.  
  78.                         EASYMAIL.PRG
  79.                              |
  80.                              + _GLOBAL.PRG
  81.                              |
  82.                              + _SET_ENV.PRG
  83.                              |
  84.                              + _PSWD.PRG
  85.                                      |
  86.                              |<-yes--OK?---no--> _END_PRG.PRG
  87.                              |
  88.                         _MAINMEN.PRG
  89.                              |
  90.        ----------------------+---------------------------------------
  91.        |                                      |                     |
  92.  _MAILOUT.PRG                            _MAILIN.PRG           _UTILITY.PRG
  93.     |                                       |                     |
  94.     + _OUTPUT.PRG -> _PRINT.PRG             + _MEMO.PRG           + _EDITUSR.PRG
  95.     |                                       |                     |        |
  96.     + _MEMO.PRG                             + _OUTPUT.PRG         |    _PICKUSR.PRG
  97.     |                                               |             |
  98.  _SNDFUNC.PRG                                   _PRINT.PRG        |
  99.     |                                                             + _PACKFILE (proc)
  100.     +------------------------------
  101.     |             |               |
  102.  _TO_USER.PRG  _WHOMAIL.PRG   _IMPTEXT.PRG
  103.